package jpa.entitys.synchro.staging;

import java.io.Serializable;
import java.math.BigDecimal;

import javax.persistence.*;

import java.util.Date;

import jpa.entitys.synchro.common.CommonEntity;

/**
 * The persistent class for the SD_CONTARCT_UTILITIES database table.
 * 
 */
@Entity
@Table(name="SD_CONTARCT_UTILITIES")
@NamedQueries({
    @NamedQuery(name = "SdContarctUtility.findAll", query = " SELECT c FROM SdContarctUtility c order by c.company,c.project,c.documentno,c.instanceNo,c.promisStagingId asc"),
    @NamedQuery(name = "SdContarctUtility.findById", query = " SELECT c FROM SdContarctUtility c WHERE c.promisStagingId = :Id "),
    @NamedQuery(name = "SdContarctUtility.findIsSync", query = " SELECT c FROM SdContarctUtility c WHERE  c.issync = :issync order by c.company,c.project,c.documentno,c.instanceNo,c.promisStagingId asc"),
    @NamedQuery(name = "SdContarctUtility.findByInstanceNo", query = " SELECT c FROM SdContarctUtility c WHERE c.instanceNo = :instanceNo And c.issync = 'N' order by c.company,c.project,c.documentno,c.status,c.seqNo asc"),
    @NamedQuery(name = "SdContarctUtility.findByDocumentNo", query = " SELECT c FROM SdContarctUtility c WHERE c.company = :company And c.project = :project And c.documentno = :documentno And c.status = :status And c.issync = :issync order by c.company,c.project,c.documentno,c.promisStagingId asc")
    })
public class SdContarctUtility extends CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name="PROMIS_STAGING_ID")
	private String promisStagingId;
	
	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}

	@Column(name="ACTION_HANDLER")
	private String actionHandler;

	@Column(name="BUILDING_PHASE_CODE")
	private String buildingPhaseCode;

	private String company;

	@Column(name="CREATED_BY")
	private String createdBy;

	@Column(name="CREATED_ON")
	private String createdOn;

	private String currency;

	private String documentno;

	@Column(name="DUE_DATE")
	private String dueDate;

	@Column(name="END_PERIOD")
	private String endPeriod;

	@Column(name="EXT_REF_KEY")
	private String extRefKey;

	@Column(name="EXT_REF_NO")
	private String extRefNo;

	@Column(name="INSTANCE_NO")
	private String instanceNo;

	private String isactive;

	private String issync;

	@Column(name="ITEM_CATEG")
	private String itemCateg;

	@Column(name="MSG_ACT_RESULT")
	private String msgActResult;

	@Column(name="MSG_ALT_DESC")
	private String msgAltDesc;

	@Column(name="MSG_CODE")
	private String msgCode;

	@Column(name="MSG_DESC")
	private String msgDesc;

	private String period;

	@Column(name="PRICE_AMOUNT")
	private String priceAmount;

	@Column(name="PRICE_UNIT")
	private String priceUnit;

	private String project;

	@Column(name="SAP_COMPANY_CODE")
	private String sapCompanyCode;

	@Column(name="SAP_PLANT_CODE")
	private String sapPlantCode;

	@Column(name="START_PERIOD")
	private String startPeriod;

	@Column(name="SYNC_CREATEDBY")
	private String syncCreatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_UPDATEDBY")
	private String syncUpdatedby;

    @Temporal( TemporalType.DATE)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="TAX_AMOUNT")
	private String taxAmount;

	@Column(name="TAX_BASE_AMOUNT")
	private String taxBaseAmount;

	@Column(name="TAX_CODE")
	private String taxCode;

	@Column(name="UPDATED_BY")
	private String updatedBy;

	@Column(name="UPDATED_ON")
	private String updatedOn;
	
	@Column(name="STATUS")
	private String status;
	
	@Column(name="FLOOR_ZONE_CODE")
	private String floorZoneCode;
	
	@Column(name="UNIT_NUMBER")
	private String unitNumber;
	
	@Column(name="CHARGE_CODE")
	private String chargeCode;
	
	@Column(name="PAY_BY")
	private String payBy;
	
	@Column(name="BUYER_PAY")
	private BigDecimal buyerPay;
	
	@Column(name="SELLER_PAY")
	private BigDecimal sellerPay;
	
	@Column(name="TYPE_OF_PERIOD")
	private String typeOfPeriod;
		
	@Column(name="SEQ_NO")
	private long seqNo;
	
	
	
    /**
	 * @return the seqNo
	 */
	public long getSeqNo() {
		return seqNo;
	}



	/**
	 * @param seqNo the seqNo to set
	 */
	public void setSeqNo(long seqNo) {
		this.seqNo = seqNo;
	}



	public SdContarctUtility() {
    }
    
    
    
	/**
	 * @return the typeOfPeriod
	 */
	public String getTypeOfPeriod() {
		return typeOfPeriod;
	}




	/**
	 * @param typeOfPeriod the typeOfPeriod to set
	 */
	public void setTypeOfPeriod(String typeOfPeriod) {
		this.typeOfPeriod = typeOfPeriod;
	}




	/**
	 * @return the floorZoneCode
	 */
	public String getFloorZoneCode() {
		return floorZoneCode;
	}



	/**
	 * @param floorZoneCode the floorZoneCode to set
	 */
	public void setFloorZoneCode(String floorZoneCode) {
		this.floorZoneCode = floorZoneCode;
	}



	/**
	 * @return the unitNumber
	 */
	public String getUnitNumber() {
		return unitNumber;
	}



	/**
	 * @param unitNumber the unitNumber to set
	 */
	public void setUnitNumber(String unitNumber) {
		this.unitNumber = unitNumber;
	}



	/**
	 * @return the chargeCode
	 */
	public String getChargeCode() {
		return chargeCode;
	}



	/**
	 * @param chargeCode the chargeCode to set
	 */
	public void setChargeCode(String chargeCode) {
		this.chargeCode = chargeCode;
	}



	/**
	 * @return the payBy
	 */
	public String getPayBy() {
		return payBy;
	}



	/**
	 * @param payBy the payBy to set
	 */
	public void setPayBy(String payBy) {
		this.payBy = payBy;
	}



	/**
	 * @return the buyerPay
	 */
	public BigDecimal getBuyerPay() {
		return buyerPay;
	}



	/**
	 * @param buyerPay the buyerPay to set
	 */
	public void setBuyerPay(BigDecimal buyerPay) {
		this.buyerPay = buyerPay;
	}



	/**
	 * @return the sellerPay
	 */
	public BigDecimal getSellerPay() {
		return sellerPay;
	}



	/**
	 * @param sellerPay the sellerPay to set
	 */
	public void setSellerPay(BigDecimal sellerPay) {
		this.sellerPay = sellerPay;
	}



	/**
	 * @return the status
	 */
	public String getStatus() {
		return status;
	}



	/**
	 * @param status the status to set
	 */
	public void setStatus(String status) {
		this.status = status;
	}



	public String getPromisStagingId() {
		return this.promisStagingId;
	}

	public void setPromisStagingId(String promisStagingId) {
		this.promisStagingId = promisStagingId;
	}

	public String getActionHandler() {
		return this.actionHandler;
	}

	public void setActionHandler(String actionHandler) {
		this.actionHandler = actionHandler;
	}

	public String getBuildingPhaseCode() {
		return this.buildingPhaseCode;
	}

	public void setBuildingPhaseCode(String buildingPhaseCode) {
		this.buildingPhaseCode = buildingPhaseCode;
	}

	public String getCompany() {
		return this.company;
	}

	public void setCompany(String company) {
		this.company = company;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public String getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(String createdOn) {
		this.createdOn = createdOn;
	}

	public String getCurrency() {
		return this.currency;
	}

	public void setCurrency(String currency) {
		this.currency = currency;
	}

	public String getDocumentno() {
		return this.documentno;
	}

	public void setDocumentno(String documentno) {
		this.documentno = documentno;
	}

	public String getDueDate() {
		return this.dueDate;
	}

	public void setDueDate(String dueDate) {
		this.dueDate = dueDate;
	}

	public String getEndPeriod() {
		return this.endPeriod;
	}

	public void setEndPeriod(String endPeriod) {
		this.endPeriod = endPeriod;
	}

	public String getExtRefKey() {
		return this.extRefKey;
	}

	public void setExtRefKey(String extRefKey) {
		this.extRefKey = extRefKey;
	}

	public String getExtRefNo() {
		return this.extRefNo;
	}

	public void setExtRefNo(String extRefNo) {
		this.extRefNo = extRefNo;
	}

	public String getInstanceNo() {
		return this.instanceNo;
	}

	public void setInstanceNo(String instanceNo) {
		this.instanceNo = instanceNo;
	}

	public String getIsactive() {
		return this.isactive;
	}

	public void setIsactive(String isactive) {
		this.isactive = isactive;
	}

	public String getIssync() {
		return this.issync;
	}

	public void setIssync(String issync) {
		this.issync = issync;
	}

	public String getItemCateg() {
		return this.itemCateg;
	}

	public void setItemCateg(String itemCateg) {
		this.itemCateg = itemCateg;
	}

	public String getMsgActResult() {
		return this.msgActResult;
	}

	public void setMsgActResult(String msgActResult) {
		this.msgActResult = msgActResult;
	}

	public String getMsgAltDesc() {
		return this.msgAltDesc;
	}

	public void setMsgAltDesc(String msgAltDesc) {
		this.msgAltDesc = msgAltDesc;
	}

	public String getMsgCode() {
		return this.msgCode;
	}

	public void setMsgCode(String msgCode) {
		this.msgCode = msgCode;
	}

	public String getMsgDesc() {
		return this.msgDesc;
	}

	public void setMsgDesc(String msgDesc) {
		this.msgDesc = msgDesc;
	}

	public String getPeriod() {
		return this.period;
	}

	public void setPeriod(String period) {
		this.period = period;
	}

	public String getPriceAmount() {
		return this.priceAmount;
	}

	public void setPriceAmount(String priceAmount) {
		this.priceAmount = priceAmount;
	}

	public String getPriceUnit() {
		return this.priceUnit;
	}

	public void setPriceUnit(String priceUnit) {
		this.priceUnit = priceUnit;
	}

	public String getProject() {
		return this.project;
	}

	public void setProject(String project) {
		this.project = project;
	}

	public String getSapCompanyCode() {
		return this.sapCompanyCode;
	}

	public void setSapCompanyCode(String sapCompanyCode) {
		this.sapCompanyCode = sapCompanyCode;
	}

	public String getSapPlantCode() {
		return this.sapPlantCode;
	}

	public void setSapPlantCode(String sapPlantCode) {
		this.sapPlantCode = sapPlantCode;
	}

	public String getStartPeriod() {
		return this.startPeriod;
	}

	public void setStartPeriod(String startPeriod) {
		this.startPeriod = startPeriod;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getTaxAmount() {
		return this.taxAmount;
	}

	public void setTaxAmount(String taxAmount) {
		this.taxAmount = taxAmount;
	}

	public String getTaxBaseAmount() {
		return this.taxBaseAmount;
	}

	public void setTaxBaseAmount(String taxBaseAmount) {
		this.taxBaseAmount = taxBaseAmount;
	}

	public String getTaxCode() {
		return this.taxCode;
	}

	public void setTaxCode(String taxCode) {
		this.taxCode = taxCode;
	}

	public String getUpdatedBy() {
		return this.updatedBy;
	}

	public void setUpdatedBy(String updatedBy) {
		this.updatedBy = updatedBy;
	}

	public String getUpdatedOn() {
		return this.updatedOn;
	}

	public void setUpdatedOn(String updatedOn) {
		this.updatedOn = updatedOn;
	}

}